UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7W1XRAdJcQPDfKpIs3NgQc0axIQ/aYnOOuwxMq6XCWk=' 
WHERE 
  key_id = '1ed83b0125d2b7e896938f6815f4997317c1789cf2ce636d591cf8d552eb32e2' 
  AND (
    token = '7W1XRAdJcQPDfKpIs3NgQc0axIQ/aYnOOuwxMq6XCWk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027