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

Query time 0.00030