UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4n6ACEvcz53RW2k4a9QNQ/zJPob/wSf6eEuu/53D6gA='
WHERE
key_id = '92e6f567daacb3c62d404dbbfbc7fe6bcb90d1b69f8d11a06ee4e50636a4b2ad'
AND (
token = '4n6ACEvcz53RW2k4a9QNQ/zJPob/wSf6eEuu/53D6gA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)