UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9QxyZ0SK7s0IVFjintPARVp7KdZuoYWUTyI5jThhItw='
WHERE
key_id = 'aa7298eb26b914e3509804fa749c9b7d90420b3a31c8feb0420cd6ed05822ecb'
AND (
token = '9QxyZ0SK7s0IVFjintPARVp7KdZuoYWUTyI5jThhItw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)