UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7B1t/jM/YoC3AhngyFm/qErMKTOMHO5rMAr3P24zvE4='
WHERE
key_id = '96c9944538b867ec8550a12452bd9447b782a08d5fe782a2c26f0f741b19cefa'
AND (
token = '7B1t/jM/YoC3AhngyFm/qErMKTOMHO5rMAr3P24zvE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)