UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'djIAJcygdKVsp90cOd4AxXBn0X5K1sEJfSUOAG0pA80=' 
WHERE 
  key_id = 'e1e682c1a8602d6eb9ab2d088ff8b8adae6bbc62b3de406a56057d4c3635b9af' 
  AND (
    token = 'djIAJcygdKVsp90cOd4AxXBn0X5K1sEJfSUOAG0pA80=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035