UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mLdKHZLrw3t8HmzLYqhUnrgfAk30yTqTViPLapsmS4E='
WHERE
key_id = 'fa420c96f9aa575f3cd9d8322f235f5e066e4835401a643b7126ce3ca2cf7fc3'
AND (
token = 'mLdKHZLrw3t8HmzLYqhUnrgfAk30yTqTViPLapsmS4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)