UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgUfTUg3PWHwedKUHWcNOB6QnYdWTZONBZFMirLOjXk='
WHERE
key_id = '42d56592f82a1ee46cafea3e272b6454b31d497c281e54b441a0a07ca8232100'
AND (
token = 'XgUfTUg3PWHwedKUHWcNOB6QnYdWTZONBZFMirLOjXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)