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