UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihSeLChzcDDoy3e1PjgEW7TSiIqwCHeiSU9Zb37kYQ4='
WHERE
key_id = '34bc0befde77ed9dac60dad42656134b1608e54ad1864c0fcf9cf20111e9c118'
AND (
token = 'ihSeLChzcDDoy3e1PjgEW7TSiIqwCHeiSU9Zb37kYQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)