UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MqHCqUGVHTrhRmQOE81CCrdYo66kIdYooKfn11UG1m8='
WHERE
key_id = '37ffdcc448daedf14bfef1c92a3d46e63c17a3f8bfb4a202a22c0b52cc35a8de'
AND (
token = 'MqHCqUGVHTrhRmQOE81CCrdYo66kIdYooKfn11UG1m8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)