UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XsXb1SHnfOtM/fNVfFc7814NwZwp1ViI1GyJXVl6ZIg=' 
WHERE 
  key_id = '3e708da452c159dfed4953f88abd22f28b0c6354ad6e84e8e1032e85eb4256fd' 
  AND (
    token = 'XsXb1SHnfOtM/fNVfFc7814NwZwp1ViI1GyJXVl6ZIg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00067