UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mibQyTbSkiyjZ5izCnq2ii3uEP1Wg3obMW+VLXyEins=' 
WHERE 
  key_id = '3cd6796ca73ad906ccda25b6f576528e57de8db31a4f6788ef23d11a798d548b' 
  AND (
    token = 'mibQyTbSkiyjZ5izCnq2ii3uEP1Wg3obMW+VLXyEins=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028