UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A2Bsi3CRHjiyzlsvr2VhrduwlUxrC+KHJjWP+dX7HkE='
WHERE
key_id = '59c3ca13625209fdeaaf2fa55ff24ae6dcd40115d6faed5159751f8b911b0eeb'
AND (
token = 'A2Bsi3CRHjiyzlsvr2VhrduwlUxrC+KHJjWP+dX7HkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)