UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Dwh9f9jQHU4z+kysiAT64whX0OKw58nCB2Dy9LtTfnU=' 
WHERE 
  key_id = 'f1264446ceba1ee5378c9a809594c7ef0b72b41e3c84ba904c3c62d9adba304c' 
  AND (
    token = 'Dwh9f9jQHU4z+kysiAT64whX0OKw58nCB2Dy9LtTfnU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027