UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ckCCODxudBI2SmR5hbaDEf4T87k40q5tdCDkLt77aco='
WHERE
key_id = '7c777268225e7a6d0359ab272ca83e0a1af61e4fd26766526023b58c857ba6f1'
AND (
token = 'ckCCODxudBI2SmR5hbaDEf4T87k40q5tdCDkLt77aco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)