UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yQTOwmBclk9P8QOIqCKIU7Mcay5q5YRh2QZ6S+pRpVs=' 
WHERE 
  key_id = '843091117eb74028c12953d435d0c772471a35cbc5cbfd8ca2a57f9db9be9d41' 
  AND (
    token = 'yQTOwmBclk9P8QOIqCKIU7Mcay5q5YRh2QZ6S+pRpVs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016