UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQPgS5h/JoyQnHz8f4dC2URjXXCtJuVkjkEvxmOktRw='
WHERE
key_id = 'f9ae69452c27d9221af39a45d4f348046437fe29bc7f3286d20463bcf8f3adbf'
AND (
token = 'LQPgS5h/JoyQnHz8f4dC2URjXXCtJuVkjkEvxmOktRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)