UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGr6HdarNkX6JkrMhnKosxe1YPDfqsHIttSElCPskkw='
WHERE
key_id = 'be436b9cec046decfa57ab84f77b4d60f8a4de96e365ae7dbcc92844ed733cfc'
AND (
token = 'mGr6HdarNkX6JkrMhnKosxe1YPDfqsHIttSElCPskkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)