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