UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7oyAC9qDI0hMeA/f46aBAJLGPZAggLHTaweXJh6QH0='
WHERE
key_id = '9d57e84e185e377a783e468260a8b544c7c812b846d5319b671745d06dba98d9'
AND (
token = 'x7oyAC9qDI0hMeA/f46aBAJLGPZAggLHTaweXJh6QH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)