UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HA1ydYrBDHzVk7kZ0Ll4UcfiVozMXAvycqZCCNbnHGM=' 
WHERE 
  key_id = 'd29c6a275c6aa1cb94c501144003b9e37fc8156a30e51c9af7902e4bcf205463' 
  AND (
    token = 'HA1ydYrBDHzVk7kZ0Ll4UcfiVozMXAvycqZCCNbnHGM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028