UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xqe6jtMEa0HFtHTU67U5iQxxCW/eJruzkrZ0M3QPWhw='
WHERE
key_id = '5ec928465ac967f0ee8a608fa00c6b4b773c0c186adcacb3b410a65413eea0a6'
AND (
token = 'Xqe6jtMEa0HFtHTU67U5iQxxCW/eJruzkrZ0M3QPWhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)