UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TqlLKYlhOd7xLD5tmWVP97H7kNz8v8j0Rxuqdws0wh4='
WHERE
key_id = '5b2df7c304bd08a45b0d3c45471fd2b12cdb22e2eaf3a0994eab5d5a58402df7'
AND (
token = 'TqlLKYlhOd7xLD5tmWVP97H7kNz8v8j0Rxuqdws0wh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)