UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1HIy69tzsmXc+GfT422JXmdbx5Tjisx8oZ2XVgxemGM=' 
WHERE 
  key_id = 'f323a278bfbb33f82b5d52d85d6a6db5c194f18b0c33dff3c4efe0ce4a8a90cd' 
  AND (
    token = '1HIy69tzsmXc+GfT422JXmdbx5Tjisx8oZ2XVgxemGM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033