UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2D8UIcGvfdTtdonyY4J23O9td5ok7QqvT4y9dEPgn58=' 
WHERE 
  key_id = '3b52a56b2c69626950945e9de70a0d6e43a1bb87bdd4497d500f6e35fd3e7c23' 
  AND (
    token = '2D8UIcGvfdTtdonyY4J23O9td5ok7QqvT4y9dEPgn58=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028