UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yFg1CtKSi7TVPJyCOg5AabgDEcg2aFLQ7YhemL113C8=' 
WHERE 
  key_id = '9fdd741cf61c3efb8a9680386464f0755bc978c95ce871bd3b9245af0152a5cd' 
  AND (
    token = 'yFg1CtKSi7TVPJyCOg5AabgDEcg2aFLQ7YhemL113C8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025