UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4+d0pSpwyTpSRttST5OoZdNtuTrRtDjvQOPvgTk4DWo='
WHERE
key_id = 'f8a14246c178546d6299abb611d45569936edba8330419a45e61fda067186025'
AND (
token = '4+d0pSpwyTpSRttST5OoZdNtuTrRtDjvQOPvgTk4DWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)