UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kId604Q/1uo3IruT5dZ09lL/9TDmCkiM5mODqbiXGh4='
WHERE
key_id = '6dc27993a9b6af5079d409c857b5160faa29a4ffd36d8a284262ba367a3a401a'
AND (
token = 'kId604Q/1uo3IruT5dZ09lL/9TDmCkiM5mODqbiXGh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)