UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1MZR4ga2JXJkTWrgHw6gHSpNyLkry2tibiRQE8qN7bI='
WHERE
key_id = '86e5b8af55abd360676eb31fd7cf8335c7e80f52769a58c1047e4c40b1a1ddd6'
AND (
token = '1MZR4ga2JXJkTWrgHw6gHSpNyLkry2tibiRQE8qN7bI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)