UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vc/NtdpOSfzvQPnqam/DJBb4fKUvc+DERO5KWrpPwbM='
WHERE
key_id = 'be9166fc421d36576cc713c465bb9061ca354df167c4a5bcc5021c81009bbb34'
AND (
token = 'vc/NtdpOSfzvQPnqam/DJBb4fKUvc+DERO5KWrpPwbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)